[dbo].[asi_GetSeasonalFullAddressKeysByFullAddressKey]

SQLServer > iMIS1521GA > Stored Procedures > dbo.asi_GetSeasonalFullAddressKeysByFullAddressKey

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@fullAddressKey	uniqueidentifier	16
@now	datetime	8

SQL Script

CREATE  PROCEDURE [dbo].[asi_GetSeasonalFullAddressKeysByFullAddressKey] (@fullAddressKey uniqueidentifier, @now datetime)
AS
BEGIN

SELECT SeasonalFullAddressKey FROM SeasonalFullAddress
WHERE FullAddressKey = @fullAddressKey
   AND BeginDate < @now
   AND (EndDate IS NULL OR EndDate > @now  OR IsSeasonalAnnually = 1)
ORDER BY BeginDate

END

GO

Uses

[dbo].[SeasonalFullAddress]
dbo